Page Control Search

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'STRSUBSTNO(\\\'{47b41e849e598e8a912e87ea28f030b7debd271459b9af7bd68d1c8fea02cd8f}1\\\',ServInfoPaneMgt.CalcNoOfSubstitutions(Rec))' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to STRSUBSTNO(\’%1\’,SERVINFOPANEMGT.CALCNOOFSUBSTITUTIONS(REC))

Seq NoPage NumberPage NameControl Name